package com.coldworks.coldjoke.manager;

public class DBCONST {

	// 数据库名称
	public static final String DB_NAME = "coldjoke.db";

	// 表名
	public static final String TB_NAME_JOKE_NEW = "new";
	public static final String TB_NAME_JOKE_HOT = "popular";
	public static final String TB_NAME_JOKE_SHIT = "shit";

	// 公用名
	public static String CREATE_TIME = "createTime";
	public static String MODIFY_TIME = "modifyTime";

	// 笑话的DB相关
	public static final String JOKE_ID = "joke_id"; // 笑话ID，Primary Key
	public static final String JOKE_INDEX = "joke_index"; // 笑话ID，Primary Key
	public static final String JOKE_TIME = "joke_time"; // 创建时间
	public static final String JOKE_TEXT = "joke_text"; // 笑话内容
	public static final String JOKE_IMG_URL = "joke_img_url";// 笑话图片的URL
	public static final String JOKE_GIF_DATA = "joke_gif_data";// GIF图存放
	public static final String JOKE_IMG_PATH = "joke_img_path";// 存放图片
	public static final String JOKE_IMG_THUMBNAIL = "joke_img_thumbnail";
	public static final String GOOD_NUM = "good_num";// 笑话中顶数
	public static final String BAD_NUM = "bad_num"; // 笑话中踩数
	public static final String REPLY_NUM = "reply_num";// 笑话回复树
	public static final String USER_ID = "user_id"; // 用户ID
	public static final String USER_NAME = "user_name"; // 用户名
	public static final String USER_ICON_URL = "user_icon_url"; // 用户头像
	public static final String JOKE_READ = "joke_read";// 是否已经度过
	public static final String JOKE_LIKED = "joke_liked";// 用户顶
	public static final String JOKE_DISLIKED = "joke_disliked";// 用户踩

	public static final String JOKE_IMG = "jokeImg"; // 笑话中包含的图片
	public static final String JOKE_TYPE = "jokeType"; // 类别
	public static final String JOKE_REPLY = "jokeReply";

}
